2016-10-10 - 28212 - Spec - Create Crystal report for EMEA #CrystalReportDevelopment
SPECIFICATIONS
28212 - Create Crystal report for EMEA
Purpose
Need to develop new Crystal reports for EMEA Region.
Admin Info
Purpose
|
Need to Create Crystal report for EMEA
|
Requested By
|
Paul Morley
|
Spec Created By
|
Venkateswara Reddy
|
Spec Created Date
|
10/10/2016
|
Spec QA by
|
Uday P
|
Objects
|
Customer Credit Report
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
20
|
2
|
Documentation
|
10
|
3
|
Development/ Config
|
60
|
6
|
Other activity
|
20
|
|
TOTAL
|
110
|
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1.
|
Need to add new field invoice number in the report.
|
Rizwan Shah
|
10/16/2016
|
Added invoice number in the report.
|
2
|
Need to add Factor address in the report.
|
Rizwan Shah
|
10/27/2016
|
Added Factor address in the report.
|
3
|
Need to create new parameters Sales Org,
Customer and Date.
|
Rizwan Shah
|
11/23/ 2016
|
Created new parameters and filtered the data based on the parameters.
|
4
|
Need to get all customers in the report.
|
Rizwan Shah
|
12/07/2016
|
Join condition changed between KNKK table and KNA1 table to get customers.
|
Functional Requirement
Purpose/WHY:
Need to create new reports for EMEA region.
In Scope:
Two new reports AR500 and AR510 reports for EMEA region.
Out of Scope:
Other AR Reports.
Solution Summary
1. Need to develop new crystal reports based on
- The customer number
- The customer name
- The customer country
- The customer email address
- Credit Control Area
- Credit Rep
- Debtor Text content
- Invoice Note content
- Factor address
2. Customer name, customer country, customer number, customer email address, Credit Control Area, Credit Rep need to be fetched from tables ADR1, KNA1 and KNKK by joining these tables.
3. Debtor Text content, Invoice Note content and factor address need to be fetched from READ_TEXT table.
Solution Details
1. Developed new crystal reports based on
- The customer number
- The customer name
- The customer country
- The customer email address
- Credit Control Area
- Credit Rep
- Debtor Text content
- Invoice Note content
- Factor address
2. Customer name, customer country, customer number, customer email address, Credit Control Area and Credit Rep are fetched from tables ADR1, KNA1 and KNKK by joining these tables.
3. Debtor Text content, Invoice Note content and factor address fetched from READ_TEXT table.
Issues
None